﻿using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

/// <summary>
/// Summary description for UserMaster
/// </summary>
public class UserMaster
{
    DataConnection data = new DataConnection();
	public UserMaster()
	{
		//
		// TODO: Add constructor logic here
		//
	}
    public DataTable gv_TheLoai()
    {
        string loai = "select * from LoaiPhim";
        return data.GetData(loai);
    }
    public DataTable gv_HangSanXuat()
    {
        string hsx = "select MaPhim,QuocGia from Phim";
        return data.GetData(hsx);
    }
    public DataTable gv_PhimMoi()
    {
        string pm = "select top 5 With Ties MaPhim,TenPhim,NamSX from Phim order by NamSX desc ";
        return data.GetData(pm);
    }
    public DataTable dl_QuangCao()
    {
        string qc = "select HinhAnh,URL from QuangCao order by UuTien";
        return data.GetData(qc);
    }

}
